How to change the date format in SQL Server?
4215-Oct-2024
Updated on 15-Oct-2024
interview
Home / DeveloperSection / Interviews / How to change the date format in SQL Server?
Hi! This is Ashutosh Kumar Verma. I am a software developer at MindStick Software Pvt Ltd since 2021. I have added some new and interesting features to the MindStick website like a story section, audio section, and merge profile feature on MindStick subdomains, etc. I love coding and I have good knowledge of SQL Database.
1 Answers
Ashutosh Kumar Verma
15-Oct-2024In SQL Server, you can use the
FORMATfunction orCONVERTfunction to change the Date format. Some of them are given below,Sample SQL Table: ‘Employees’ with the columns “EmpId, EmpName, CreationDate, Gender, Salary”
Example-
Using FORMAT()
Using CONVERT()
1.
2.